Documentation of Replication Archive for "Campaign Contributions, Reciprocity, and Gender Solidarity"

Order:
To replicate the data campaign contributions analysis from the matched data, run givingAnalysis.R and csAnalysis.R.  Those
two scripts can be run in any order.  To rebuild the matched data from its sources, run buildGivingData.py.  To get descriptive
statistics, run descriptives.R.


Codebooks:
*Codebook.pdf: A codebook that describes the meaning of all of the variables.


Data:
*Data/categorized_leadership.csv: Classifies which legislators held mezzanine and top leadership positions in each congress.
*Data/civil_issue_bills.csv: The number of bills in the civil rights issue area sponsored by each legislator during each congress. 
*Data/fec_icpsr_ids.csv: A mapping from the candidate IDs used in the FEC's donation data to ICPSR IDs used in the other data
*Data/Figure2_Figure3_Table9_Table10.RDS: Dataset of LPAC giving used to create Figures 2 and 3 and Tables 9 and 10.
*Data/FragaData.csv: The race and gender of congressional candidates from 2006-2018.
*Data/full_member_to_candidate_giving.csv: The amount of giving from incumbent legislators to generl election candidates for 
                                           their chamber from 2006 to 2020.
*Data/general_candidates_2020_complete.csv: A supplement to the Fraga Data that extends it to 2020.
*Data/GeneralSenateCandidates_06-10.csv: A supplement to the Fraga Data that extends it for Senate candidates between 2006 to 2010.
*Data/HousePatch.csv: A patch to the Fraga data for legislators who did not run for reelection during the study period as well
                      as some discrepancies in House candidates.
*Data/house_orig_cosponsor_network.rds: Dyadic dataset of House cosponsorship
*Data/HSall_members.csv: Includes data for the legislators' NOMINATE scores.
*Data/intersectional_copartisan_donations.csv: The data for whether each minority female legislator and their matched white female
                                               and minority male colleagues gave to each minority female candidate.
*Data/intersectional_copartisan_donations_amount.csv: The data for how much each minority female legislator and their matched white female
                                                      and minority male colleagues gave to each minority female candidate.
*Data/mentors.csv: A list of legislators who were identified as mentors to women in the CAWP interviews.
*Data/poc_copartisan_donations.csv: The data for whether each minority legislator and their matched white colleague
                                    gave to each minority candidate.
*Data/poc_copartisan_donations_amount.csv: The data for how mch each minority legislator and their matched white colleague
                                           gave to each minority candidate.
*Data/senate_orig_cosponsor_network.rds: Dyadic dataset of Senate cosponsorship
*Data/SenatePatch.csv: A patch to the Fraga data for legislators who did not run for reelection during the study period as well
                       as some discrepancies in Senate candidates.
*Data/Table1.RDS: Dataset used to create Table 1. Combines member of Congress, candidate, and FEC data.
*Data/women_copartisan_donations.csv: The data for whether each female legislator and their matched male colleague
                                      gave to each female candidate.
*Data/women_copartisan_donations_amount.csv: The data for how much each female legislator and their matched male colleague
                                             gave to each female candidate.

Code:
*Code/buildGivingData.py: Runs the matching procedure to build the data for women_copartisan_donations.csv, 
                          women_copartisan_donations_amount.csv, poc_copartisan_donations.csv, 
                          poc_copartisan_donations_amount.csv, intersectional_copartisan_donations.csv,
                          and intersectional_copartisan_donations_amount.csv.
*Code/csAnalysis.R: Runs the cosponsorship analysis to produce Tables 7-8.
*Code/descriptives.R: Generates Table 1, 9 and 10, and Figure 2 and 3
*Code/givingAnalysis.R: Runs the giving analysis for Tables 2-6, Figures 4-5, and Tables 11-13.


Software:

*R 4.5.0
*R Packages:
**dplyr: 1.1.4
**ggplot2: 3.5.2
**gridExtra: 2.3
**lfe: 3.1.1
**texreg: 1.39.4
**tidyverse_2.0.0
**kableExtra_1.4.0

*Python 3.9.1
*Python Modules:
**xlrd: 2.0.1
**numpy: 1.21.0
**scip: 1.7.1


Data Sources:
*categorized_leadership.csv: Compiled based on Wikipedia pages for the associated leadership positions as well ask the
 House Republican Conference, Senate Republican Conference, House Democratic Caucus, and Senate Democratic Caucus pages.
*civil_issue_bills.csv, house_orig_cosponsor_network.rds, senate_orig_cosponsor_network.rds: Congressional Bills Project 
data from the 93rd Congress to the 116th Congress.  E. Scott Adler and 
John Wilkerson, Congressional Bills Project: (years of data), NSF 00880066 and 00880061. The views expressed are those of 
the authors and not the National Science Foundation.
*fec_icpsr_ids.csv: A crosswalk file generated by combining ProPublica's Congress API data and Bonica's DIME Data: Bonica, 
Adam. "Database on ideology, money in politics, and elections (DIME)." Harvard Dataverse 2 (2015).
*full_member_to_candidate_giving.csv: Generated by the authors using publicly available FEC donations data from fec.gov
*FragaData.csv: Fraga and Hassell (2021) "Are Minority and Women Candidates Penalized by Party Politics? Race, 
 Gender, and Access to Party Support."
*HousePatch.csv, SenatePatch.csv, general_candidates_2020_complete.csv, and GeneralSenateCandidates_06-10.csv all represent
 original data collection efforts to update the Fraga data.  Election data was pulled from Wikipedia elections pages
 and race and gender were characterized based on internet searches.
*HSall_members.csv: Downloaded from Voteview.com. Lewis, Jeffrey B., Keith Poole, Howard Rosenthal, Adam Boche, 
 Aaron Rudkin, and Luke Sonnet (2025). Voteview: Congressional Roll-Call Votes Database. https://voteview.com/
*mentors.csv: Compiled from two interview databases.  Center for American Women and Politics. 2019. ``Center for
 American Women and Politics (CWP) Interviews with Women Members of the 103rd and 104th Congresses." and Center
 for American Women and Politics. 2024.  "History of Women in the U.S. Congress."
*Table1.RDS: Compiled based on FEC data combined with original data on the timing of primary elections.